On the Master server dump a backup of the database you want to resync [cc]mysqldump –skip-lock-tables –single-transaction –flush-logs –hex-blob –master-data=2 -q | … Continue reading Resync mysql master and slave without master downtime